IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'spTemployees_Update')
	BEGIN
		PRINT 'Dropping Procedure spTemployees_Update'
		DROP  Procedure  spTemployees_Update
	END

GO

PRINT 'Creating Procedure spTemployees_Update'
GO
Create Procedure dbo.spTemployees_Update
	( 	  
		@FEMPNO char(), 
		@FEMPFNAME char() = null, 
		@FEMPLNAME char() = null, 
		@FEMPDEPART char() = null, 
		@FEMPEMAIL char() = null, 
		@FEMPGROUP char() = null
	)
AS
  /* 
    ------------------------------------------------------------------------------
    - Change History
    - --------------
    - Date          Description
    ------------------------------------------------------------------------------
    - 8/23/2007    Initial version Updated
    ------------------------------------------------------------------------------
  */

	-- Declare the required variables

	-- Update the required new record
	UPDATE Temployees
	SET
		FEMPFNAME = @FEMPFNAME, 
		FEMPLNAME = @FEMPLNAME, 
		FEMPDEPART = @FEMPDEPART, 
		FEMPEMAIL = @FEMPEMAIL, 
		FEMPGROUP = @FEMPGROUP		
	WHERE FEMPNO = @FEMPNO

	-- Return to calling method
	RETURN
	
GO
